# -*- coding: utf-8 -*-

import scrapy


class DatascrapyItem(scrapy.Item):
    # define the fields for your item here like:
    # name = scrapy.Field()
    pass


class DbRowItem(scrapy.Item):
    sysName = scrapy.Field()
    dbName = scrapy.Field()
    tableName = scrapy.Field()
    rowNums = scrapy.Field()
    dataSize = scrapy.Field()
    fragmentRate = scrapy.Field()
    ip = scrapy.Field()


class DbSlowSqlItem(scrapy.Item):
    sysName = scrapy.Field()
    dbName = scrapy.Field()
    sqlId = scrapy.Field()
    startTime = scrapy.Field()
    newestStartTime = scrapy.Field()
    exeNum = scrapy.Field()
    selSumTime = scrapy.Field()
    selTheShortest = scrapy.Field()
    selMaxRow = scrapy.Field()
    selTheLongest = scrapy.Field()
    sqlContext = scrapy.Field()
    gmtCreate = scrapy.Field()
    ip = scrapy.Field()


class TableInfoItem(scrapy.Item):
    dbName = scrapy.Field()
    tableName = scrapy.Field()
    engineName = scrapy.Field()
    tableRow = scrapy.Field()
    tableSize = scrapy.Field()
